NTISthis.com

Evidence Guide: ICTPRG431 - Apply query language in relational databases

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTPRG431 - Apply query language in relational databases

What evidence can you provide to prove your understanding of each of the following citeria?

Determine requirements of developing queries

  1. Identify terminologies applicable to query language
  2. Identify and build queries using required tools and environment
Identify terminologies applicable to query language

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify and build queries using required tools and environment

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write queries to extract required information

  1. Sort and selectively retrieve values through query writing
  2. Aggregate records by multiple attributes using an expression
  3. Sort and filter aggregated records using an expression
  4. Create queries and retrieve records from multiple tables
  5. Retrieve records from multiple tables using different expressions and approaches
  6. Filter records from multiple tables using an expression
  7. Retrieve records from multiple tables using expressions, set operators and set logic
  8. Construct and execute sub-queries
Sort and selectively retrieve values through query writing

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Aggregate records by multiple attributes using an expression

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Sort and filter aggregated records using an expression

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create queries and retrieve records from multiple tables

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Retrieve records from multiple tables using different expressions and approaches

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Filter records from multiple tables using an expression

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Retrieve records from multiple tables using expressions, set operators and set logic

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Construct and execute sub-queries

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform calculations and use expressions in queries

  1. Perform a calculation on numeric values and an operation on text values using an expression
  2. Perform an operation on date and time values using functions
  3. Aggregate values and obtain required output using an expression
Perform a calculation on numeric values and an operation on text values using an expression

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform an operation on date and time values using functions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Aggregate values and obtain required output using an expression

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and manipulate tables

  1. Identify required columns, data types, keys, relationships, indexes and constraints
  2. Manipulate tables according to specific requirements
Identify required columns, data types, keys, relationships, indexes and constraints

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manipulate tables according to specific requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and use views and stored procedures

  1. Create views according to information requirements
  2. Retrieve and save data using a view and transactions
  3. Drop a view from a database
  4. Retrieve, insert and modify data using created and stored procedures according to information requirements
  5. Create and execute stored procedures using one or more parameters
  6. Drop a stored procedure from database
  7. Create and test database triggers and perform specific required data-related functions
Create views according to information requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Retrieve and save data using a view and transactions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Drop a view from a database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Retrieve, insert and modify data using created and stored procedures according to information requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and execute stored procedures using one or more parameters

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Drop a stored procedure from database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and test database triggers and perform specific required data-related functions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

develop, store and execute at least three queries, and retrieve and extract data at least three times

perform at least three calculations using control statements, operators and functions

prepare and manipulate at least three tables to meet specific requirements

create and use at least two views and at least two stored procedures according to task requirements.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

information gathering methods that may be used to apply query language in relational databases

industry standard database management systems (DBMS)

methods of connecting to DBMS

using data definition language (DDL), data manipulation language (DML) and data control language (DCL)

data analysis techniques

data mining

data source characteristics

information system features

required systems and procedures that may be used to apply query language in relational databases.